Skip Headers

Oracle® Transparent Gateway for Sybase Administrator's Guide 10g Release 2 (10.2) for HP Tru64 UNIX Part Number B14285-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# A Data Type Conversion

This appendix contains the following section:

- Data Type Conversion

## Data Type Conversion

The gateway converts Sybase data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Sybase | Oracle | Comment
--- | --- | ---
BINARY | RAW | -
BIT | NUMBER(3) | -
CHAR | CHAR | -
DATETIME | DATE | -
DECIMAL | NUMBER(18) | -
DOUBLE PRECISION | FLOAT(49) | -
FLOAT | FLOAT(49) | -
IMAGE | LONG RAW | -
INT | NUMBER(10) | NUMBER range is -2,147,483,647 to 2,147,483,647
MONEY | NUMBER(p[,s]) | -
NCHAR | Not supported | -
NUMERIC | NUMBER(p[,s]) | -
NVARCHAR | Not supported | -
REAL | FLOAT(23) | -
SMALLDATETIME | DATE | -
SMALLINT | NUMBER(5) | NUMBER range is -32,767 to 32,767
SMALL MONEY | NUMBER(p[,s]) | -
TEXT | LONG | -
TINYINT | NUMBER(3) | -
VARBINARY | RAW | -
VARCHAR | VARCHAR2 | -